package com.online.dao;

import com.online.entity.StudentAnswer;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface StudentAnswerMapper {

    int insertARecord(StudentAnswer studentAnswer);

    List<StudentAnswer> selectAStudentAnswer(@Param("studentNumber") String studentNumber, @Param("examId") Integer examId);

    List<Integer> selectExamIdByStudentNumber(String studentNumber);

    List<StudentAnswer> selectOptionAnswer(@Param("studentNumber") String studentNumber, @Param("examId") Integer examId);

    List<StudentAnswer> selectBlanksAnswer(@Param("studentNumber") String studentNumber, @Param("examId") Integer examId);

    int deleteARecord(int examId);

    List<StudentAnswer> showStudentNumberByExamId(Integer examId);

    List<StudentAnswer> showStudentAnswerList(String studentNumber);

    int deleteByStudentNumber(String studentNumber);
}
